Overview

Dataset statistics

Number of variables21
Number of observations1796
Missing cells108
Missing cells (%)0.3%
Duplicate rows12
Duplicate rows (%)0.7%
Total size in memory592.2 KiB
Average record size in memory337.7 B

Variable types

NUM18
CAT3

Reproduction

Analysis started2023-11-23 13:47:47.537203
Analysis finished2023-11-23 13:49:17.104208
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
Dataset has 12 (0.7%) duplicate rows Duplicates
SPB1__Motor__Temperature has a high cardinality: 1662 distinct values High cardinality
X__Axis__Drive_Load has a high cardinality: 623 distinct values High cardinality
X__Motor__Torque has a high cardinality: 615 distinct values High cardinality
C1__Axis__Speed is highly correlated with C1__Axis__Actual_Feed_RateHigh Correlation
C1__Axis__Actual_Feed_Rate is highly correlated with C1__Axis__SpeedHigh Correlation
C1__Motor__Power is highly correlated with C1__Axis__Rotary_SpeedHigh Correlation
C1__Axis__Rotary_Speed is highly correlated with C1__Motor__PowerHigh Correlation
C1__Motor__Torque is highly correlated with C1__Motor__CurrentHigh Correlation
C1__Motor__Current is highly correlated with C1__Motor__TorqueHigh Correlation
SPB1__Axis__Position is highly correlated with C1__Axis__PositionHigh Correlation
C1__Axis__Position is highly correlated with SPB1__Axis__PositionHigh Correlation
SPB1__Motor__Current is highly correlated with SPB1__Axis__Drive_Load and 2 other fieldsHigh Correlation
SPB1__Axis__Drive_Load is highly correlated with SPB1__Motor__Current and 2 other fieldsHigh Correlation
SPB1__Motor__Power is highly correlated with SPB1__Axis__Drive_Load and 2 other fieldsHigh Correlation
SPB1__Motor__Torque is highly correlated with SPB1__Axis__Drive_Load and 2 other fieldsHigh Correlation
X__Axis__Position is highly correlated with SPB1__Axis__SpeedHigh Correlation
SPB1__Axis__Speed is highly correlated with X__Axis__PositionHigh Correlation
X__Motor__Current is highly skewed (γ1 = 29.87847993) Skewed
C1__Axis__Actual_Feed_Rate has 1190 (66.3%) zeros Zeros
C1__Axis__Position has 18 (1.0%) zeros Zeros
C1__Axis__Rotary_Speed has 111 (6.2%) zeros Zeros
C1__Axis__Speed has 1190 (66.3%) zeros Zeros
C1__Motor__Power has 1193 (66.4%) zeros Zeros
SPB1__Axis__Drive_Load has 345 (19.2%) zeros Zeros
SPB1__Axis__Rotary_Speed has 321 (17.9%) zeros Zeros
SPB1__Axis__Speed has 324 (18.0%) zeros Zeros
SPB1__Motor__Current has 395 (22.0%) zeros Zeros
SPB1__Motor__Power has 393 (21.9%) zeros Zeros
SPB1__Motor__Torque has 395 (22.0%) zeros Zeros
X__Axis__Rotary_Speed has 250 (13.9%) zeros Zeros
X__Motor__Current has 19 (1.1%) zeros Zeros

Variables

SPB1__Motor__Temperature
Categorical

HIGH CARDINALITY
UNIFORM
Distinct count1662
Unique (%)92.7%
Missing4
Missing (%)0.2%
Memory size14.2 KiB
56.511948
 
2
56.66504
 
2
47.085648
 
2
46.962456
 
2
57.476868
 
2
Other values (1657)
1782
ValueCountFrequency (%) 
56.511948 2 0.1%
 
56.66504 2 0.1%
 
47.085648 2 0.1%
 
46.962456 2 0.1%
 
57.476868 2 0.1%
 
53.90001 2 0.1%
 
57.025146 2 0.1%
 
49.90001 2 0.1%
 
56.185993 2 0.1%
 
44.301445 2 0.1%
 
Other values (1652) 1772 98.7%
 
(Missing) 4 0.2%
 

Length

Max length11
Mean length8.547327394
Min length3
ValueCountFrequency (%) 
Decimal_Number 10 45.5%
 
Uppercase_Letter 7 31.8%
 
Other_Punctuation 2 9.1%
 
Lowercase_Letter 2 9.1%
 
Connector_Punctuation 1 4.5%
 
ValueCountFrequency (%) 
Common 13 59.1%
 
Latin 9 40.9%
 
ValueCountFrequency (%) 
ASCII 22 100.0%
 

C1__Axis__Actual_Feed_Rate
Real number (ℝ)

HIGH CORRELATION
ZEROS
Distinct count14
Unique (%)0.8%
Missing4
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean-1064.154221
Minimum-4086.72
Maximum11160
Zeros1190
Zeros (%)66.3%
Memory size14.2 KiB

Quantile statistics

Minimum-4086.72
5-th percentile-3819.5996
Q1-3819.5996
median0
Q30
95-th percentile0
Maximum11160
Range15246.72
Interquartile range (IQR)3819.5996

Descriptive statistics

Standard deviation1957.887552
Coefficient of variation (CV)-1.839853203
Kurtosis6.132382322
Mean-1064.154221
Median Absolute Deviation (MAD)1614.816906
Skewness0.5920442404
Sum-1906964.364
Variance3833323.668
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1190 66.3%
 
-3819.5996 515 28.7%
 
-325.42502 61 3.4%
 
-3819.6 9 0.5%
 
11160 8 0.4%
 
-4086.72 1 0.1%
 
8308.906 1 0.1%
 
-60.111256 1 0.1%
 
1123.2 1 0.1%
 
5875.2 1 0.1%
 
Other values (4) 4 0.2%
 
(Missing) 4 0.2%
 
ValueCountFrequency (%) 
-4086.72 1 0.1%
 
-3819.6 9 0.5%
 
-3819.5996 515 28.7%
 
-325.42502 61 3.4%
 
-141.54727 1 0.1%
 
ValueCountFrequency (%) 
11160 8 0.4%
 
10627.2 1 0.1%
 
8308.906 1 0.1%
 
5875.2 1 0.1%
 
3556.9067 1 0.1%
 

C1__Axis__Drive_Load
Real number (ℝ≥0)

Distinct count821
Unique (%)45.8%
Missing4
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean5.554206036
Minimum0.12817383
Maximum20.281982
Zeros0
Zeros (%)0.0%
Memory size14.2 KiB

Quantile statistics

Minimum0.12817383
5-th percentile2.69500738
Q13.129577625
median4.6478272
Q37.60803225
95-th percentile10.876465
Maximum20.281982
Range20.15380817
Interquartile range (IQR)4.478454625

Descriptive statistics

Standard deviation2.951323307
Coefficient of variation (CV)0.5313672716
Kurtosis0.7371347069
Mean5.554206036
Median Absolute Deviation (MAD)2.420284257
Skewness1.099317315
Sum9953.137216
Variance8.710309264
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.9296875 12 0.7%
 
3.2287598 12 0.7%
 
2.947998 11 0.6%
 
3.0273438 10 0.6%
 
3.2043457 10 0.6%
 
2.9785156 9 0.5%
 
2.8564453 9 0.5%
 
2.923584 9 0.5%
 
3.363037 9 0.5%
 
2.886963 9 0.5%
 
Other values (811) 1692 94.2%
 
ValueCountFrequency (%) 
0.12817383 1 0.1%
 
0.20141602 1 0.1%
 
0.8483887 1 0.1%
 
1.2878418 1 0.1%
 
1.4099121 1 0.1%
 
ValueCountFrequency (%) 
20.281982 1 0.1%
 
20.08667 1 0.1%
 
18.048096 1 0.1%
 
17.376709 1 0.1%
 
15.985107 1 0.1%
 

C1__Axis__Position
Real number (ℝ)

HIGH CORRELATION
ZEROS
Distinct count709
Unique (%)39.6%
Missing4
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean-4703.76459
Minimum-33826.75
Maximum1878.6045
Zeros18
Zeros (%)1.0%
Memory size14.2 KiB

Quantile statistics

Minimum-33826.75
5-th percentile-28173.29625
Q1-5373.789375
median119.99999
Q3312
95-th percentile1878.6045
Maximum1878.6045
Range35705.3545
Interquartile range (IQR)5685.789375

Descriptive statistics

Standard deviation9591.539775
Coefficient of variation (CV)-2.039119856
Kurtosis1.457647435
Mean-4703.76459
Median Absolute Deviation (MAD)7462.086827
Skewness-1.685886724
Sum-8429146.146
Variance91997635.26
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1878.6045 202 11.2%
 
360 79 4.4%
 
359.99997 55 3.1%
 
264 50 2.8%
 
360.00003 47 2.6%
 
288 44 2.4%
 
312 43 2.4%
 
240 38 2.1%
 
216 37 2.1%
 
192 35 1.9%
 
Other values (699) 1162 64.7%
 
ValueCountFrequency (%) 
-33826.75 1 0.1%
 
-33769.457 1 0.1%
 
-33693.062 1 0.1%
 
-33629.402 1 0.1%
 
-33559.38 2 0.1%
 
ValueCountFrequency (%) 
1878.6045 202 11.2%
 
1878.6038 1 0.1%
 
1852.2941 1 0.1%
 
1741.0477 1 0.1%
 
1569.2941 1 0.1%
 

C1__Axis__Rotary_Speed
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS
Distinct count280
Unique (%)15.6%
Missing4
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean7.595420904
Minimum0
Maximum70.86549
Zeros111
Zeros (%)6.2%
Memory size14.2 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10.001021794
median0.00332083
Q324.238995
95-th percentile24.266584
Maximum70.86549
Range70.86549
Interquartile range (IQR)24.23797321

Descriptive statistics

Standard deviation11.93414548
Coefficient of variation (CV)1.571228986
Kurtosis2.241165827
Mean7.595420904
Median Absolute Deviation (MAD)10.49258414
Skewness1.39776676
Sum13610.99426
Variance142.4238284
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.000255 131 7.3%
 
0.000766 115 6.4%
 
0 111 6.2%
 
0.000511 89 5.0%
 
0.001277242 70 3.9%
 
0.002299036 70 3.9%
 
0.001021794 67 3.7%
 
0.001788139 54 3.0%
 
0.001532691 44 2.4%
 
0.002043588 38 2.1%
 
Other values (270) 1003 55.8%
 
ValueCountFrequency (%) 
0 111 6.2%
 
0.000255 131 7.3%
 
0.000511 89 5.0%
 
0.000766 115 6.4%
 
0.001021794 67 3.7%
 
ValueCountFrequency (%) 
70.86549 1 0.1%
 
70.86013 1 0.1%
 
70.85988 3 0.2%
 
70.858345 1 0.1%
 
70.854256 1 0.1%
 

C1__Axis__Speed
Real number (ℝ)

HIGH CORRELATION
ZEROS
Distinct count14
Unique (%)0.8%
Missing4
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean-1064.161023
Minimum-4069.44
Maximum11160
Zeros1190
Zeros (%)66.3%
Memory size14.2 KiB

Quantile statistics

Minimum-4069.44
5-th percentile-3819.5996
Q1-3819.5996
median0
Q30
95-th percentile0
Maximum11160
Range15229.44
Interquartile range (IQR)3819.5996

Descriptive statistics

Standard deviation1957.807709
Coefficient of variation (CV)-1.839766414
Kurtosis6.128511962
Mean-1064.161023
Median Absolute Deviation (MAD)1614.793635
Skewness0.5915515183
Sum-1906976.553
Variance3833011.025
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1190 66.3%
 
-3819.5996 515 28.7%
 
-325.42502 61 3.4%
 
-3819.6 9 0.5%
 
11160 8 0.4%
 
10592.64 1 0.1%
 
5840.64 1 0.1%
 
3591.4668 1 0.1%
 
-123.73315 1 0.1%
 
1088.64 1 0.1%
 
Other values (4) 4 0.2%
 
(Missing) 4 0.2%
 
ValueCountFrequency (%) 
-4069.44 1 0.1%
 
-3819.6 9 0.5%
 
-3819.5996 515 28.7%
 
-325.42502 61 3.4%
 
-141.54727 1 0.1%
 
ValueCountFrequency (%) 
11160 8 0.4%
 
10592.64 1 0.1%
 
8343.467 1 0.1%
 
5840.64 1 0.1%
 
3591.4668 1 0.1%
 

C1__Motor__Current
Real number (ℝ)

HIGH CORRELATION
Distinct count623
Unique (%)34.8%
Missing4
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean2.740043518
Minimum-13.982298
Maximum18.245543
Zeros0
Zeros (%)0.0%
Memory size14.2 KiB

Quantile statistics

Minimum-13.982298
5-th percentile-9.504821
Q12.60472075
median3.3634639
Q34.8381036
95-th percentile7.555297
Maximum18.245543
Range32.227841
Interquartile range (IQR)2.23338285

Descriptive statistics

Standard deviation4.939516369
Coefficient of variation (CV)1.802714569
Kurtosis2.056935526
Mean2.740043518
Median Absolute Deviation (MAD)3.016865879
Skewness-1.448961009
Sum4910.157985
Variance24.39882196
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.5208127 16 0.9%
 
2.8992915 16 0.9%
 
2.927856 15 0.8%
 
2.7707515 14 0.8%
 
12.868284 13 0.7%
 
2.599365 13 0.7%
 
2.5779417 13 0.7%
 
2.7350461 12 0.7%
 
2.720764 12 0.7%
 
2.5636594 11 0.6%
 
Other values (613) 1657 92.3%
 
ValueCountFrequency (%) 
-13.982298 1 0.1%
 
-10.797362 1 0.1%
 
-9.961852 1 0.1%
 
-9.826171 1 0.1%
 
-9.726195 1 0.1%
 
ValueCountFrequency (%) 
18.245543 1 0.1%
 
18.074156 1 0.1%
 
16.188902 1 0.1%
 
15.567625 1 0.1%
 
14.289366 1 0.1%
 

C1__Motor__Power
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS
Distinct count154
Unique (%)8.6%
Missing4
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean229.2496849
Minimum0
Maximum4601.184
Zeros1193
Zeros (%)66.4%
Memory size14.2 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q3607.10065
95-th percentile830.76935
Maximum4601.184
Range4601.184
Interquartile range (IQR)607.10065

Descriptive statistics

Standard deviation397.5000546
Coefficient of variation (CV)1.733917562
Kurtosis17.14266224
Mean229.2496849
Median Absolute Deviation (MAD)317.5420229
Skewness2.858166967
Sum410815.4353
Variance158006.2934
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1193 66.4%
 
54.776 29 1.6%
 
693.82935 19 1.1%
 
666.44135 16 0.9%
 
698.394 15 0.8%
 
684.7 15 0.8%
 
657.312 14 0.8%
 
739.476 14 0.8%
 
50.211334 13 0.7%
 
639.05334 11 0.6%
 
Other values (144) 453 25.2%
 
ValueCountFrequency (%) 
0 1193 66.4%
 
18.258667 1 0.1%
 
22.823334 1 0.1%
 
31.952667 1 0.1%
 
36.517334 1 0.1%
 
ValueCountFrequency (%) 
4601.184 1 0.1%
 
3135.926 1 0.1%
 
3085.7146 1 0.1%
 
3044.6326 1 0.1%
 
3021.8093 1 0.1%
 

C1__Motor__Torque
Real number (ℝ)

HIGH CORRELATION
Distinct count759
Unique (%)42.4%
Missing4
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean5.937077009
Minimum-30.669
Maximum39.884
Zeros0
Zeros (%)0.0%
Memory size14.2 KiB

Quantile statistics

Minimum-30.669
5-th percentile-20.705
Q15.651
median6.9505
Q310.819
95-th percentile17.21595
Maximum39.884
Range70.553
Interquartile range (IQR)5.168

Descriptive statistics

Standard deviation10.7752736
Coefficient of variation (CV)1.814912217
Kurtosis2.040136857
Mean5.937077009
Median Absolute Deviation (MAD)6.582283452
Skewness-1.432321471
Sum10639.242
Variance116.1065211
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5.666 13 0.7%
 
6.398 13 0.7%
 
6.367 12 0.7%
 
6.118 12 0.7%
 
5.853 11 0.6%
 
5.682 11 0.6%
 
5.806 11 0.6%
 
5.604 11 0.6%
 
6.429 10 0.6%
 
6.258 10 0.6%
 
Other values (749) 1678 93.4%
 
ValueCountFrequency (%) 
-30.669 1 0.1%
 
-22.994 1 0.1%
 
-21.935 1 0.1%
 
-21.842 3 0.2%
 
-21.826 2 0.1%
 
ValueCountFrequency (%) 
39.884 1 0.1%
 
39.526 1 0.1%
 
35.525 1 0.1%
 
34.17 1 0.1%
 
31.446 1 0.1%
 

SPB1__Axis__Drive_Load
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS
Distinct count1347
Unique (%)75.3%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean27.35474875
Minimum0
Maximum100
Zeros345
Zeros (%)19.2%
Memory size14.2 KiB

Quantile statistics

Minimum0
5-th percentile0
Q15.2597287
median16.888588
Q359.750595
95-th percentile70.8707848
Maximum100
Range100
Interquartile range (IQR)54.4908663

Descriptive statistics

Standard deviation27.16136763
Coefficient of variation (CV)0.9929306197
Kurtosis-1.168618442
Mean27.35474875
Median Absolute Deviation (MAD)24.27055222
Skewness0.6622308092
Sum48965.00026
Variance737.7398913
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 345 19.2%
 
100 7 0.4%
 
32.92249 2 0.1%
 
7.1315656 2 0.1%
 
10.962415 2 0.1%
 
68.82789 2 0.1%
 
53.048347 2 0.1%
 
64.46222 2 0.1%
 
17.33208 2 0.1%
 
70.56677 2 0.1%
 
Other values (1337) 1422 79.2%
 
(Missing) 6 0.3%
 
ValueCountFrequency (%) 
0 345 19.2%
 
1.4e-45 1 0.1%
 
8.4e-45 1 0.1%
 
6.22e-43 1 0.1%
 
7.59e-42 1 0.1%
 
ValueCountFrequency (%) 
100 7 0.4%
 
72.93336 1 0.1%
 
72.85063 1 0.1%
 
72.82571 1 0.1%
 
72.79876 1 0.1%
 

SPB1__Axis__Position
Real number (ℝ)

HIGH CORRELATION
Distinct count1435
Unique (%)80.2%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean-85898.50775
Minimum-507709.34
Maximum284.32373
Zeros6
Zeros (%)0.3%
Memory size14.2 KiB

Quantile statistics

Minimum-507709.34
5-th percentile-423014.511
Q1-81394.2525
median-23518.402
Q3-1990.8225
95-th percentile74.0339055
Maximum284.32373
Range507993.6637
Interquartile range (IQR)79403.43

Descriptive statistics

Standard deviation136283.6912
Coefficient of variation (CV)-1.586566458
Kurtosis1.65231096
Mean-85898.50775
Median Absolute Deviation (MAD)104491.6907
Skewness-1.730377028
Sum-153758328.9
Variance1.857324448e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
74.0334 16 0.9%
 
74.03337 13 0.7%
 
74.03339 13 0.7%
 
74.03334 9 0.5%
 
74.03333 9 0.5%
 
74.03344 9 0.5%
 
74.03343 8 0.4%
 
74.033325 8 0.4%
 
74.033356 8 0.4%
 
74.03336 8 0.4%
 
Other values (1425) 1689 94.0%
 
ValueCountFrequency (%) 
-507709.34 1 0.1%
 
-506849.94 1 0.1%
 
-505704.06 1 0.1%
 
-504749.16 1 0.1%
 
-503698.78 2 0.1%
 
ValueCountFrequency (%) 
284.32373 1 0.1%
 
225.2503 1 0.1%
 
170.0683 2 0.1%
 
74.035065 1 0.1%
 
74.0344 2 0.1%
 

SPB1__Axis__Rotary_Speed
Real number (ℝ≥0)

ZEROS
Distinct count648
Unique (%)36.2%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean40.58939055
Minimum0
Maximum660.4863
Zeros321
Zeros (%)17.9%
Memory size14.2 KiB

Quantile statistics

Minimum0
5-th percentile0
Q146.67148775
median46.819499
Q358.45908225
95-th percentile58.55753665
Maximum660.4863
Range660.4863
Interquartile range (IQR)11.7875945

Descriptive statistics

Standard deviation30.0914871
Coefficient of variation (CV)0.7413633634
Kurtosis199.7636526
Mean40.58939055
Median Absolute Deviation (MAD)17.90819495
Skewness9.309230617
Sum72655.00909
Variance905.4975957
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 321 17.9%
 
0.000601 70 3.9%
 
46.807777 11 0.6%
 
46.806576 11 0.6%
 
46.80898 11 0.6%
 
46.811386 11 0.6%
 
46.80718 10 0.6%
 
46.80357 10 0.6%
 
58.512127 9 0.5%
 
46.813187 8 0.4%
 
Other values (638) 1318 73.4%
 
ValueCountFrequency (%) 
0 321 17.9%
 
0.000601 70 3.9%
 
0.003606332 1 0.1%
 
0.5885533 1 0.1%
 
8.571649 1 0.1%
 
ValueCountFrequency (%) 
660.4863 1 0.1%
 
660.4662 1 0.1%
 
58.670807 1 0.1%
 
58.663593 2 0.1%
 
58.658184 1 0.1%
 

SPB1__Axis__Speed
Real number (ℝ)

HIGH CORRELATION
ZEROS
Distinct count11
Unique (%)0.6%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean-39028.21776
Minimum-57294
Maximum0.5885533
Zeros324
Zeros (%)18.0%
Memory size14.2 KiB

Quantile statistics

Minimum-57294
5-th percentile-57294
Q1-57294
median-45835.2
Q3-45835.2
95-th percentile0
Maximum0.5885533
Range57294.58855
Interquartile range (IQR)11458.8

Descriptive statistics

Standard deviation21389.57646
Coefficient of variation (CV)-0.5480541435
Kurtosis-0.3840305674
Mean-39028.21776
Median Absolute Deviation (MAD)17295.78824
Skewness1.147511947
Sum-69860509.79
Variance457513981.1
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
-45835.2 868 48.3%
 
-57294 524 29.2%
 
0 324 18.0%
 
-0.5885533 35 1.9%
 
0.5885533 33 1.8%
 
-3.5313199 1 0.1%
 
0.013532639 1 0.1%
 
0.009021759 1 0.1%
 
-9121.435 1 0.1%
 
-34855.695 1 0.1%
 
(Missing) 6 0.3%
 
ValueCountFrequency (%) 
-57294 524 29.2%
 
-45835.2 868 48.3%
 
-34855.695 1 0.1%
 
-9518.378 1 0.1%
 
-9121.435 1 0.1%
 
ValueCountFrequency (%) 
0.5885533 33 1.8%
 
0.013532639 1 0.1%
 
0.009021759 1 0.1%
 
0 324 18.0%
 
-0.5885533 35 1.9%
 

SPB1__Motor__Current
Real number (ℝ)

HIGH CORRELATION
ZEROS
Distinct count921
Unique (%)51.5%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean-19.26698674
Minimum-55.125
Maximum13.412109
Zeros395
Zeros (%)22.0%
Memory size14.2 KiB

Quantile statistics

Minimum-55.125
5-th percentile-52.7425051
Q1-43.894409
median-9.310547
Q3-3.8759766
95-th percentile0
Maximum13.412109
Range68.537109
Interquartile range (IQR)40.0184324

Descriptive statistics

Standard deviation20.20963861
Coefficient of variation (CV)-1.048925755
Kurtosis-1.244101295
Mean-19.26698674
Median Absolute Deviation (MAD)18.21800991
Skewness-0.6907447594
Sum-34487.90626
Variance408.4294928
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 395 22.0%
 
-3.8862305 19 1.1%
 
-3.8964844 18 1.0%
 
-3.8759766 18 1.0%
 
-3.9067383 12 0.7%
 
-3.8657227 12 0.7%
 
-3.927246 10 0.6%
 
-3.9169922 10 0.6%
 
-3.8554688 9 0.5%
 
-3.947754 9 0.5%
 
Other values (911) 1278 71.2%
 
ValueCountFrequency (%) 
-55.125 1 0.1%
 
-54.909668 1 0.1%
 
-54.78662 1 0.1%
 
-54.612305 1 0.1%
 
-54.55078 1 0.1%
 
ValueCountFrequency (%) 
13.412109 1 0.1%
 
7.5776367 1 0.1%
 
6.9624023 1 0.1%
 
0 395 22.0%
 
-3.8041992 1 0.1%
 

SPB1__Motor__Power
Real number (ℝ)

HIGH CORRELATION
ZEROS
Distinct count782
Unique (%)43.7%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean9398.196934
Minimum-3684.58
Maximum26062.842
Zeros393
Zeros (%)21.9%
Memory size14.2 KiB

Quantile statistics

Minimum-3684.58
5-th percentile0
Q11827.7838
median5401.1495
Q320746.31225
95-th percentile24917.3356
Maximum26062.842
Range29747.422
Interquartile range (IQR)18918.52845

Descriptive statistics

Standard deviation9412.472807
Coefficient of variation (CV)1.001519001
Kurtosis-1.244046562
Mean9398.196934
Median Absolute Deviation (MAD)8405.189856
Skewness0.6485643645
Sum16822772.51
Variance88594644.35
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 393 21.9%
 
1837.4546 35 1.9%
 
1827.7838 32 1.8%
 
1847.1254 23 1.3%
 
1818.1129 15 0.8%
 
1856.7963 14 0.8%
 
1866.467 13 0.7%
 
5396.314 9 0.5%
 
2504.7407 9 0.5%
 
1808.4421 8 0.4%
 
Other values (772) 1239 69.0%
 
ValueCountFrequency (%) 
-3684.58 1 0.1%
 
-2939.9272 1 0.1%
 
-1702.0632 1 0.1%
 
-7.6068115 1 0.1%
 
-6.257324 1 0.1%
 
ValueCountFrequency (%) 
26062.842 1 0.1%
 
25956.463 1 0.1%
 
25898.44 1 0.1%
 
25811.402 1 0.1%
 
25792.06 1 0.1%
 

SPB1__Motor__Torque
Real number (ℝ)

HIGH CORRELATION
ZEROS
Distinct count937
Unique (%)52.3%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean-27.34447933
Minimum-78.144
Maximum19.026
Zeros395
Zeros (%)22.0%
Memory size14.2 KiB

Quantile statistics

Minimum-78.144
5-th percentile-74.921
Q1-62.214
median-13.174
Q3-5.501
95-th percentile0
Maximum19.026
Range97.17
Interquartile range (IQR)56.713

Descriptive statistics

Standard deviation28.67744011
Coefficient of variation (CV)-1.04874698
Kurtosis-1.244317714
Mean-27.34447933
Median Absolute Deviation (MAD)25.85522116
Skewness-0.6901795843
Sum-48946.618
Variance822.395571
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 395 22.0%
 
-5.514 18 1.0%
 
-5.501 18 1.0%
 
-5.474 13 0.7%
 
-5.541 13 0.7%
 
-5.487 12 0.7%
 
-5.528 12 0.7%
 
-5.555 10 0.6%
 
-5.569 10 0.6%
 
-5.609 9 0.5%
 
Other values (927) 1280 71.3%
 
ValueCountFrequency (%) 
-78.144 1 0.1%
 
-78.036 1 0.1%
 
-77.764 1 0.1%
 
-77.398 1 0.1%
 
-77.33 2 0.1%
 
ValueCountFrequency (%) 
19.026 1 0.1%
 
10.742 1 0.1%
 
9.886 1 0.1%
 
0 395 22.0%
 
-5.406 1 0.1%
 

X__Axis__Drive_Load
Categorical

HIGH CARDINALITY
Distinct count623
Unique (%)34.8%
Missing6
Missing (%)0.3%
Memory size14.2 KiB
1.0742188
 
13
0.07324219
 
12
0.17700195
 
12
1.1169434
 
10
0.29296875
 
10
Other values (618)
1733
ValueCountFrequency (%) 
1.0742188 13 0.7%
 
0.07324219 12 0.7%
 
0.17700195 12 0.7%
 
1.1169434 10 0.6%
 
0.29296875 10 0.6%
 
1.763916 10 0.6%
 
0.8911133 9 0.5%
 
0.88500977 9 0.5%
 
0.14648438 9 0.5%
 
0.13427734 9 0.5%
 
Other values (613) 1687 93.9%
 

Length

Max length24
Mean length9.04454343
Min length1
ValueCountFrequency (%) 
Decimal_Number 10 58.8%
 
Other_Punctuation 2 11.8%
 
Lowercase_Letter 2 11.8%
 
Uppercase_Letter 2 11.8%
 
Dash_Punctuation 1 5.9%
 
ValueCountFrequency (%) 
Common 13 76.5%
 
Latin 4 23.5%
 
ValueCountFrequency (%) 
ASCII 17 100.0%
 

X__Axis__Position
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count1246
Unique (%)69.6%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean382.9619169
Minimum0
Maximum650.30963
Zeros5
Zeros (%)0.3%
Memory size14.2 KiB

Quantile statistics

Minimum0
5-th percentile266.182187
Q1266.4203575
median324.87103
Q3374.97296
95-th percentile650.249369
Maximum650.30963
Range650.30963
Interquartile range (IQR)108.5526025

Descriptive statistics

Standard deviation148.3388379
Coefficient of variation (CV)0.3873461861
Kurtosis-0.3433131288
Mean382.9619169
Median Absolute Deviation (MAD)120.7428778
Skewness1.078836308
Sum685501.8313
Variance22004.41084
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
650.24225 16 0.9%
 
324.8704 11 0.6%
 
324.86975 11 0.6%
 
650.2419 10 0.6%
 
324.87003 10 0.6%
 
650.2434 9 0.5%
 
324.87045 9 0.5%
 
324.87033 9 0.5%
 
324.87006 9 0.5%
 
324.8701 8 0.4%
 
Other values (1236) 1688 94.0%
 
ValueCountFrequency (%) 
0 5 0.3%
 
0.009765625 2 0.1%
 
266.14133 1 0.1%
 
266.14282 1 0.1%
 
266.1446 1 0.1%
 
ValueCountFrequency (%) 
650.30963 1 0.1%
 
650.29016 1 0.1%
 
650.288 1 0.1%
 
650.2828 1 0.1%
 
650.2787 1 0.1%
 

X__Axis__Rotary_Speed
Real number (ℝ≥0)

ZEROS
Distinct count163
Unique (%)9.1%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean2.440822497
Minimum0
Maximum100.27344
Zeros250
Zeros (%)13.9%
Memory size14.2 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10.009765625
median0.13671875
Q30.3515625
95-th percentile0.95703125
Maximum100.27344
Range100.27344
Interquartile range (IQR)0.341796875

Descriptive statistics

Standard deviation14.15607324
Coefficient of variation (CV)5.79971434
Kurtosis40.55874765
Mean2.440822497
Median Absolute Deviation (MAD)4.3192206
Skewness6.466731389
Sum4369.07227
Variance200.3944095
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 250 13.9%
 
0.009765625 243 13.5%
 
0.01953125 51 2.8%
 
0.087890625 44 2.4%
 
0.12695312 37 2.1%
 
0.078125 36 2.0%
 
0.16601562 35 1.9%
 
0.0390625 35 1.9%
 
0.13671875 33 1.8%
 
0.15625 31 1.7%
 
Other values (153) 995 55.4%
 
ValueCountFrequency (%) 
0 250 13.9%
 
0.009765625 243 13.5%
 
0.01953125 51 2.8%
 
0.029296875 26 1.4%
 
0.0390625 35 1.9%
 
ValueCountFrequency (%) 
100.27344 1 0.1%
 
100.21484 1 0.1%
 
100.20508 1 0.1%
 
100.18555 1 0.1%
 
100.166016 2 0.1%
 

X__Motor__Current
Real number (ℝ)

SKEWED
ZEROS
Distinct count610
Unique (%)34.1%
Missing6
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean1.613457162
Minimum-6.91864
Maximum1248
Zeros19
Zeros (%)1.1%
Memory size14.2 KiB

Quantile statistics

Minimum-6.91864
5-th percentile-0.513885487
Q1-0.05218506
median0.2746582
Q30.5548096
95-th percentile0.9036255
Maximum1248
Range1254.91864
Interquartile range (IQR)0.60699466

Descriptive statistics

Standard deviation41.70306511
Coefficient of variation (CV)25.84702346
Kurtosis891.9790395
Mean1.613457162
Median Absolute Deviation (MAD)2.823326559
Skewness29.87847993
Sum2888.088319
Variance1739.14564
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 19 1.1%
 
-0.01373291 12 0.7%
 
0.4147339 12 0.7%
 
0.4586792 11 0.6%
 
-0.019226074 10 0.6%
 
0.29663086 10 0.6%
 
-0.15655518 9 0.5%
 
0.05218506 9 0.5%
 
0.5932617 9 0.5%
 
0.40100098 8 0.4%
 
Other values (600) 1681 93.6%
 
ValueCountFrequency (%) 
-6.91864 1 0.1%
 
-5.7540894 2 0.1%
 
-4.817505 1 0.1%
 
-4.430237 1 0.1%
 
-4.0759277 2 0.1%
 
ValueCountFrequency (%) 
1248 2 0.1%
 
6.303406 1 0.1%
 
5.869446 1 0.1%
 
5.836487 1 0.1%
 
5.809021 1 0.1%
 

X__Motor__Torque
Categorical

HIGH CARDINALITY
Distinct count615
Unique (%)34.4%
Missing6
Missing (%)0.3%
Memory size14.2 KiB
0
 
17
0.521
 
11
-0.138
 
10
0.642
 
9
0.021
 
9
Other values (610)
1734
ValueCountFrequency (%) 
0 17 0.9%
 
0.521 11 0.6%
 
-0.138 10 0.6%
 
0.642 9 0.5%
 
0.021 9 0.5%
 
0.03 9 0.5%
 
-0.02 9 0.5%
 
-0.13 9 0.5%
 
0.401 9 0.5%
 
0.362 8 0.4%
 
Other values (605) 1690 94.1%
 

Length

Max length6
Mean length5.139198218
Min length1
ValueCountFrequency (%) 
Decimal_Number 10 55.6%
 
Uppercase_Letter 4 22.2%
 
Lowercase_Letter 2 11.1%
 
Other_Punctuation 1 5.6%
 
Dash_Punctuation 1 5.6%
 
ValueCountFrequency (%) 
Common 12 66.7%
 
Latin 6 33.3%
 
ValueCountFrequency (%) 
ASCII 18 100.0%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

SPB1__Motor__TemperatureC1__Axis__Actual_Feed_RateC1__Axis__Drive_LoadC1__Axis__PositionC1__Axis__Rotary_SpeedC1__Axis__SpeedC1__Motor__CurrentC1__Motor__PowerC1__Motor__TorqueSPB1__Axis__Drive_LoadSPB1__Axis__PositionSPB1__Axis__Rotary_SpeedSPB1__Axis__SpeedSPB1__Motor__CurrentSPB1__Motor__PowerSPB1__Motor__TorqueX__Axis__Drive_LoadX__Axis__PositionX__Axis__Rotary_SpeedX__Motor__CurrentX__Motor__Torque
059.610542-3819.59964.864502-564.1494024.245382-3819.59964.498901698.394008.8117.243908-8768.37258.515133-57294.0-4.2758792524.0823-6.0710.80566406266.188700.0097660.2169800.216
159.34928-3819.59965.377197-627.8094524.256876-3819.59964.498901698.394009.7147.220807-9818.76258.510323-57294.0-4.2553712514.4116-6.0302.972412266.159700.0097660.8020020.802
259.367516-3819.59965.529785-672.3714624.250746-3819.59964.556030702.958709.1847.200350-10391.70258.503110-57294.0-4.2451172504.7407-6.0033.930664266.148770.0097661.0574341.06
359.269466-3819.59965.432129-736.0314324.249979-3819.59964.656005721.217359.5427.185362-11346.60258.504314-57294.0-4.2348632504.7407-6.0584.095459266.141330.0195311.1068731.106
459.209194-3819.59965.114746-806.0574024.258154-3819.59964.598877712.0880011.2247.207621-12396.99258.510323-57294.0-4.2861332514.4116-6.0581.8005371266.144600.0195310.4916380.486
559.14919-3819.59965.114746-876.0832524.244871-3819.59964.977355771.428659.3877.225293-13447.38258.515730-57294.0-4.2861332524.0823-6.0711.4343262266.149660.0390620.3872680.384
659.2493-3819.59964.785156-939.7433524.244616-3819.59964.577453707.523308.3907.256448-14402.28158.511524-57294.0-4.2861332533.7532-6.0981.2207031266.153350.0097660.3268430.326
759.2493-3819.59965.566406-1003.4032024.241550-3819.59964.998779775.993359.5747.250866-15357.18258.509724-57294.0-4.2861332533.7532-6.0851.0009766266.156400.0097660.2691650.269
859.116924-3819.59963.918457-1079.7955024.247936-3819.59963.670532566.018708.5317.236337-16503.06258.512730-57294.0-4.2963872533.7532-6.0980.6286621266.159420.0097660.1730350.167
959.219067-3819.59965.120850-1149.8213024.247936-3819.59964.891662757.734709.0447.252181-17553.45158.510323-57294.0-4.3066412543.4240-6.1120.4272461266.161770.0000000.1181030.115

Last rows

SPB1__Motor__TemperatureC1__Axis__Actual_Feed_RateC1__Axis__Drive_LoadC1__Axis__PositionC1__Axis__Rotary_SpeedC1__Axis__SpeedC1__Motor__CurrentC1__Motor__PowerC1__Motor__TorqueSPB1__Axis__Drive_LoadSPB1__Axis__PositionSPB1__Axis__Rotary_SpeedSPB1__Axis__SpeedSPB1__Motor__CurrentSPB1__Motor__PowerSPB1__Motor__TorqueX__Axis__Drive_LoadX__Axis__PositionX__Axis__Rotary_SpeedX__Motor__CurrentX__Motor__Torque
178662.0437280.03.03955124.0000040.0002550.02.6636350.05.77560.878390-30288.74646.858868-45835.2-43.60986320618.174-61.9021.4343262324.879240.3125000.3817750.387
178761.755330.03.44238324.0000020.0033210.02.7350460.06.75660.165062-31205.45546.747673-45835.2-48.91113323113.244-69.6021.4465332324.878900.4394530.3900150.406
178862.0983430.03.32641624.0000080.0022990.02.7636100.06.36764.986290-31816.58846.650900-45835.2-47.47558622436.287-67.4842.6367188324.874000.7714840.6701660.716
178961.79320.03.09448224.0000100.0020440.02.6993410.06.10265.291990-32733.29546.862473-45835.2-49.25976623287.318-69.7922.368164324.870300.0390620.6921390.626
179061.79320.02.81372124.0000000.0038320.02.5850830.05.65162.597040-33649.99646.873894-45835.2-47.29101622349.250-67.0353.6254883324.868930.4003910.9228520.994
179161.8081930.02.83813523.9999980.0022990.02.6707760.05.66660.633305-34413.92046.727837-45835.2-43.50732420560.150-61.6571.348877324.871900.5273440.4202270.409
179261.9437640.03.00293024.0000080.0000000.02.7207640.05.86854.151047-35254.22046.876900-45835.2-37.32422017649.234-53.0200.75683594324.887180.2148440.1593020.227
179362.2210770.03.03955123.9999870.0025540.02.7207640.05.88450.130196-35636.18446.765102-45835.2-34.24804716198.612-48.7690.25634766324.889281.8261720.1593020.041
179461.880340.02.47192423.9999770.0017880.02.5279540.04.90335.832497-36552.90046.760296-45835.2-22.42529310608.883-31.7521.0925293324.892360.9179690.3405760.274
179562.216930.02.92358423.9999920.0022990.02.5636590.05.68221.951164-37316.81046.945420-45835.2-12.8481456082.942-18.1850.76904297324.894870.3808590.2032470.203